In this lab, Owen from Google Marketing will show you how you can use the Gemini app and Gemini in Google Sheets to take unstructured data from an image and turn it into an organized and analyzed spreadsheet.

You’ll apply multimodal prompting by taking an image and extracting information from it in the form of structured data. You’ll also use the =AI() function in Google Sheets. Instead of typing complex formulas to perform data analysis, you’ll simply type in what you want in your own words and let Gemini do the heavy lifting for you.

What you'll gain:

• New insights : Unlock data trapped in images, PDFs, and other non-traditional sources

• Easier analysis : Use natural language prompts in Sheets to analyze information without needing to learn complex formulas

• More time for strategy : Spend less time on manual data entry and more time acting on the insights you find

Apply what you learn:

In the lab, we’ll demonstrate how to analyze customer reviews for an e-commerce company. However, you can get the most out of this lab when you apply these techniques to your own work. As you follow along, try adapting the prompts to unlock your own unstructured data and the types of analysis you want to perform on it. For example, you might want to categorize customer support tickets based on their descriptions or summarize some open-ended survey responses.

Let's unlock the data you already have!

Google AI Pro required. This lab requires higher access to Google’s most capable models. As a learner enrolled in this certificate, you are eligible for a complimentary 3-month trial subscription to help you build your portfolio of AI solutions. Please ensure you have activated your trial before beginning this lab.

This lab is optional, but highly recommended to help you practice using AI for work. You do not need to complete this lab to progress through the course or earn your certificate from Google.